GenerateFromCellRanges(SheetView,CellRange[],Boolean) Method

In This Topic

Generates a chart from cell ranges.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub GenerateFromCellRanges( _
   ByVal sheetView As SheetView, _
   ByVal cellRanges() As CellRange, _
   ByVal autoSwitch As Boolean _
)

'Usage
 
Dim instance As SpreadChart
Dim sheetView As SheetView
Dim cellRanges() As CellRange
Dim autoSwitch As Boolean
 
instance.GenerateFromCellRanges(sheetView, cellRanges, autoSwitch)

public void GenerateFromCellRanges( 
   SheetView sheetView,
   CellRange[] cellRanges,
   bool autoSwitch
)

Parameters

sheetView: The sheet view.
cellRanges: The cell ranges.
autoSwitch: if set to true, the processing switches rows and columns automatically, if necessary.

Remarks

The category parameter is for the category cell range; the seriesName parameter is for the series name cell range; and the data parameter is for the data cell range. The sheetView parameter is how the three cell ranges relate to the SheetView. This function can be used to rebuild a chart.

Example

This example uses the GenerateFromCellRanges method.

C#
Visual Basic

Reference

SpreadChart Class
SpreadChart Members
Overload List